CREATE VIEW [dbo].[vSoaInvoiceSummaryInvoice] WITH SCHEMABINDING
AS
SELECT
       CAST(i.[REFERENCE_NUM] AS VARCHAR(20)) AS InvoiceId,
       i.[ORG_CODE] AS FinancialEntityId,
       i.[INVOICE_NUM] AS InvoiceNumber,
       i.[INVOICE_DATE] AS InvoiceDate,
       i.[BT_ID] AS BillToPartyId,
       i.[ST_ID] AS SoldToPartyId,
       i.[DESCRIPTION] AS Description,
       i.[CHARGES] AS InvoiceAmount,
       i.[CREDITS] AS PaymentAdjustmentAmount,
       i.[BALANCE] AS Balance,
       i.[SOURCE_SYSTEM],
       i.[REFERENCE_NUM],
       i.[ORIGINATING_TRANS_NUM],
       i.[INVOICE_TYPE]   
  FROM [dbo].[Invoice] i

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaInvoiceSummaryInvoice] ON [dbo].[vSoaInvoiceSummaryInvoice] ([InvoiceId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaInvoiceSummaryInvoice_BillToPartyId] ON [dbo].[vSoaInvoiceSummaryInvoice] ([BillToPartyId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaInvoiceSummaryInvoice_InvoiceNumber] ON [dbo].[vSoaInvoiceSummaryInvoice] ([InvoiceNumber]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaInvoiceSummaryInvoice_SoldToPartyId] ON [dbo].[vSoaInvoiceSummaryInvoice] ([SoldToPartyId]) ON [PRIMARY]
GO